﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetTelefonoByNumero')
	BEGIN
		DROP  Procedure  GetTelefonoByNumero
	END

GO

CREATE Procedure GetTelefonoByNumero

	(
		@numero nvarchar(10)
	)

AS

BEGIN

	SELECT
	[IdBien] AS 'IdBien',
	[Marca] AS 'Marca',
	[Modelo] AS 'Modelo',
	[NroCelular] AS 'NroCelular',
	[TipoCelular] AS 'TipoCelular'
	FROM [telefono]
	WHERE [NroCelular] = @numero

END

GO


GRANT EXEC ON GetTelefonoByNumero TO PUBLIC

GO


